UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'NmPDi8mTh7xJx2jrSDqqc4cQpM1j30K78ThbVR89OTM=' 
WHERE 
  key_id = '13cb9a48ff40c002dfe4ecf9efd117eb8d636c1ee7b8a3257a29c50975d135fd' 
  AND (
    token = 'NmPDi8mTh7xJx2jrSDqqc4cQpM1j30K78ThbVR89OTM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028