UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '/V8S7gOfwsWehUoHJWZr6CcvG3IJz7enAse67q9iuhQ=' 
WHERE 
  key_id = '40a64013bf90552a3cf94ab80b2638c55f2ccc8ffd265e6fcc58e7dbaf9b4c49' 
  AND (
    token = '/V8S7gOfwsWehUoHJWZr6CcvG3IJz7enAse67q9iuhQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047