UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tpuW94rgJPBcfw7hDt9Ffstx6OIsvhSGm355YqOEqx8='
WHERE
key_id = '78223f75b9f8e8bf351edf64373d406f141072685c99b507d52f56f1155e680c'
AND (
token = 'tpuW94rgJPBcfw7hDt9Ffstx6OIsvhSGm355YqOEqx8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)