UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZcNFx7ezWMCVBq3hnywHZmwiSSrdAU4wHYj1N1qA0h4='
WHERE
key_id = '381f2f26c8c25f9b06b56e9688dacb3886df4c5162b7eb3e413db3f3a10add71'
AND (
token = 'ZcNFx7ezWMCVBq3hnywHZmwiSSrdAU4wHYj1N1qA0h4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)