UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'eHz3npFLKI7Rue4xGtLallJ4lCD7pnYMTXpHeqz2fi0=' 
WHERE 
  key_id = '36e4f829c903a8461e5103f51625e276897860f5693bf0f6ebf8b13726d5d44a' 
  AND (
    token = 'eHz3npFLKI7Rue4xGtLallJ4lCD7pnYMTXpHeqz2fi0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00042