UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'w7wJoAVNWmXoOA7m1eDJtq2PO1EonnzkjGZ2xKlh3qk='
WHERE
key_id = '4849cc479a5116d0783f80e0042f4a5d68e0e5ae63b590f3fb61ae929ee47abd'
AND (
token = 'w7wJoAVNWmXoOA7m1eDJtq2PO1EonnzkjGZ2xKlh3qk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)