UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1BuK2yZFGzpFrnj+Bxjp+GapKcv/qnW0VDj2sSt703c='
WHERE
key_id = '1aeb2aa6c0451c047cb21ddf4404de14548491011224531e0401bc7236c440b0'
AND (
token = '1BuK2yZFGzpFrnj+Bxjp+GapKcv/qnW0VDj2sSt703c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)