UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lOAxDNErO68PufgKzmhNgJnVxbLr2PbaYM4JGMfjPwY='
WHERE
key_id = 'e0e6e1aa9f9d5971d393172c3efac97013adf1a107fa51492306b6edb2a5e156'
AND (
token = 'lOAxDNErO68PufgKzmhNgJnVxbLr2PbaYM4JGMfjPwY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)