UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QaX6jbW4TkrGWU0/9Sp+tbTzNA2JEG7gMqfer/5/Jeg='
WHERE
key_id = '419cf58b4a35cfdc5c6b74dd311d9a04522f25889009097eeab77924ff758160'
AND (
token = 'QaX6jbW4TkrGWU0/9Sp+tbTzNA2JEG7gMqfer/5/Jeg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)