UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '0JMsGiDpw3fyuL55F7B6MPowr1ZqmUb2dfTHA8+l6KQ=' 
WHERE 
  key_id = '6b5098a71cfd5cd18d8bd4044c4f44aa4fd5d861be862d556f7a90f8d874bf01' 
  AND (
    token = '0JMsGiDpw3fyuL55F7B6MPowr1ZqmUb2dfTHA8+l6KQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032