UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd9xlbpH/LqUgmdCdsXfpD4fF2gVxw7G5f24VLsH0Nz0='
WHERE
key_id = '097f2a46a88b12a30649bb2e98ccb6c5891d6e15bd3cda0ffc445aa8168f7e3e'
AND (
token = 'd9xlbpH/LqUgmdCdsXfpD4fF2gVxw7G5f24VLsH0Nz0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)