UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZxjBO2b9YBQoUSUZq//kkbnkDV/uud12YEqEaIC7Oq0='
WHERE
key_id = 'f4d19962a002a93215a0b5b3cf8fec15f469b26139f46c5e0883b56431681909'
AND (
token = 'ZxjBO2b9YBQoUSUZq//kkbnkDV/uud12YEqEaIC7Oq0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)