UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zCVK4R1G+JdT2TdTmVtGBrFtzWNmxFRuyKFQrFwkSzo='
WHERE
key_id = '7cd0b93519e2461c6c186f736b30a57dac10f7e67a590e5aaa538d26eb3bca27'
AND (
token = 'zCVK4R1G+JdT2TdTmVtGBrFtzWNmxFRuyKFQrFwkSzo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)