UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zCM/FrOxD9//rfZMGDNSotXhbPdTKX2wZ2rpnwPee78='
WHERE
key_id = '1585c119a87e76cba8da347a14f8d3573ce28470ddf113b3c8bde9023ad8facd'
AND (
token = 'zCM/FrOxD9//rfZMGDNSotXhbPdTKX2wZ2rpnwPee78='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)