UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zKgLQAozwkPUx3c9waf/e3Wz9YL1yUIi8jA/gYneuRc='
WHERE
key_id = '86037ae362ba8bcd26e8a279f88efe05b3662f16a91d5f78bf52bd72061de1c6'
AND (
token = 'zKgLQAozwkPUx3c9waf/e3Wz9YL1yUIi8jA/gYneuRc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)