UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WveudGks/Z1CpwrrOlVx05vpUwXSGZzf6D3d6DRrjr4='
WHERE
key_id = 'd0500116c412fbe0d6b2926fb1c1a1cc63f673580c0d4df9ea4ff53483262e5a'
AND (
token = 'WveudGks/Z1CpwrrOlVx05vpUwXSGZzf6D3d6DRrjr4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)