UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sP0AJYgn+xhA8gF2kZt0DoBCQVNbaePcNcqz8s/zWHw='
WHERE
key_id = '863eb2d86365f93bb0d5d1062c01a165270f1e5bbf15e814764c71ac9e1e63f0'
AND (
token = 'sP0AJYgn+xhA8gF2kZt0DoBCQVNbaePcNcqz8s/zWHw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)