UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'CvV7065fbmi726v4vd162PTcWa2jpF4Vht8se6T/cm8=' 
WHERE 
  key_id = '9bafcb1674181631534a93d208e0fc476388bf404fab952ac942cc7f46583a63' 
  AND (
    token = 'CvV7065fbmi726v4vd162PTcWa2jpF4Vht8se6T/cm8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028