UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CmKUfVWSCDLz3HGZXBqmawN26aAXAVM2tU6J8l27m7s='
WHERE
key_id = '645fad14b258d258d01bdac447b15043c1799d962d3a8c31d78affd65c74ff0c'
AND (
token = 'CmKUfVWSCDLz3HGZXBqmawN26aAXAVM2tU6J8l27m7s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)