UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LjGpelYtlttE7UnWXLlvccjBG+GW/MIbBnzds8ZJ3Os='
WHERE
key_id = '518a8b9422862d167d0c8d6bad6aa957d7f8ed62c0595e69254ad33a32a1b698'
AND (
token = 'LjGpelYtlttE7UnWXLlvccjBG+GW/MIbBnzds8ZJ3Os='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)