UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0wrQxbSHgB+k0u3NM3+kfecCNzZX/saEojD+crjoWU8='
WHERE
key_id = '16823d274e884b8162988def9ccd371f0872e890577f31d4bfb209e576900ac2'
AND (
token = '0wrQxbSHgB+k0u3NM3+kfecCNzZX/saEojD+crjoWU8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)