UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'SCOIBaxN0/mDJm5h4TtZLR8cMrY5PeE+7SvyWMvUVwM=' 
WHERE 
  key_id = 'a10a1f31672d436b1ead8ace3a8f89d4a3912d8d14912c2d6969718bfb5aecc9' 
  AND (
    token = 'SCOIBaxN0/mDJm5h4TtZLR8cMrY5PeE+7SvyWMvUVwM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025