UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a7ZqZl8E0CLHR0JUfyFebVpwHvlEf3cLScOr8b27fIg='
WHERE
key_id = 'fef7d15d085e9a2948e2e942332c431a76db61d627b8bd171a89fc5bdc18001e'
AND (
token = 'a7ZqZl8E0CLHR0JUfyFebVpwHvlEf3cLScOr8b27fIg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)