UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PrjMyXpTuuMB1mO6zIrEi2w3a9MMuzvkznN+iTjncI8='
WHERE
key_id = 'e3cdc46582d0c25174a786984a9422395b94fa023d430384fb5b24de5ca67535'
AND (
token = 'PrjMyXpTuuMB1mO6zIrEi2w3a9MMuzvkznN+iTjncI8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)