UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XG89XXA5CXCqEPPUyUm6gvkuLKFqUz1DHQi59z+fOHw='
WHERE
key_id = 'ce2fd69fd3ce6c197c4c8ebb0d54eb86208759b4b8bc2870f9aef9b365f7ea35'
AND (
token = 'XG89XXA5CXCqEPPUyUm6gvkuLKFqUz1DHQi59z+fOHw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)