UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'YVCLW1oD7nFkyc4RciDp0Q55cIEvLl5Rb92hzb2VlXQ=' 
WHERE 
  key_id = '4a7e07ebfbd41e94b8b5e01c779f4a73495cbf7eef0803c3444470125f03b03b' 
  AND (
    token = 'YVCLW1oD7nFkyc4RciDp0Q55cIEvLl5Rb92hzb2VlXQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025