UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kAJSeuGE1yoxtVIqSmSG0xE+pk6woXyooOIHgT+EWq0='
WHERE
key_id = 'a9818c931c6902f4fe262623d53be02fcf95372d063f3b62c15ee498109b990f'
AND (
token = 'kAJSeuGE1yoxtVIqSmSG0xE+pk6woXyooOIHgT+EWq0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)