UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'z+91FZWD5Yqo3LosvfxqsaPMg1e67rqdiZC2IIgyQMM=' 
WHERE 
  key_id = 'f443824267e8b76cb5b6f936b4c3130934dcf2303d9787c07e78fc7a8e5f9619' 
  AND (
    token = 'z+91FZWD5Yqo3LosvfxqsaPMg1e67rqdiZC2IIgyQMM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034