UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HxmTk2jJLc21zJ36wz/vVfdkBLYkppCMALxbtz1kGME='
WHERE
key_id = '0f2ccb9b2711a3acb693d54e20d1139c53a832138f053d98f2b8287014c4d2c9'
AND (
token = 'HxmTk2jJLc21zJ36wz/vVfdkBLYkppCMALxbtz1kGME='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)