UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zj8mHP6Up1dDYQb7Yp3J/q5Rc9HwNr08Y38W5PadRGg='
WHERE
key_id = '81f8b6d0aad9be3e43edef5654e9b9991351d5555e2472ec57abf7aea8457d9a'
AND (
token = 'zj8mHP6Up1dDYQb7Yp3J/q5Rc9HwNr08Y38W5PadRGg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)