UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8rw0VBpTkIOBNjLnGAHgLcIyLxyV6/2MVMOu0k+WF5g='
WHERE
key_id = 'b1d88a31eb81872ce270a480322f8ef3806c5f2d59e7462ed8c9d712200a9c47'
AND (
token = '8rw0VBpTkIOBNjLnGAHgLcIyLxyV6/2MVMOu0k+WF5g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)