UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sfuCLnC5b58K8jW6ocM76LZimvAEcKPtGmTwgqHKmT0='
WHERE
key_id = 'c4a6eb5e3d601eebff74a784f29f2eb0d4d8fd8d536b7a7b8198b365530a216d'
AND (
token = 'sfuCLnC5b58K8jW6ocM76LZimvAEcKPtGmTwgqHKmT0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)