UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'gQf9QQr1fp5OPYNkx9JkYmtBD19rdYaDbXlUQ9Mwkg8=' 
WHERE 
  key_id = 'aacfb9f22849727f7ccfb169869a2cf88638fc0a3b3a058abc4f9bd2a2261c9a' 
  AND (
    token = 'gQf9QQr1fp5OPYNkx9JkYmtBD19rdYaDbXlUQ9Mwkg8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026