UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'v0S4C3q1S5Nv38aM9O8aX71CtQwaqadqbYKoLHfqhTw=' 
WHERE 
  key_id = '0d317327279b5b0c7062472307ac369a8249d383a3994b9b2b25d31ffff560e4' 
  AND (
    token = 'v0S4C3q1S5Nv38aM9O8aX71CtQwaqadqbYKoLHfqhTw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034