UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'mxWuK45AFu4Ke/KUZ2jZjyEeplNKENjFGd4LnCPy5gg=' 
WHERE 
  key_id = 'e289abf8cad6cadb4e4ee6645ec3c8999b04db79f897f0e3b695b2f723b212b7' 
  AND (
    token = 'mxWuK45AFu4Ke/KUZ2jZjyEeplNKENjFGd4LnCPy5gg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026