UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p8FaHJJAL0W6K2bmorhaBce9yfg8NsQPILZ9932UhEk='
WHERE
key_id = '9be6a81137b754f0d9ec1ebf1edb07d6fca8ae5679e91f3116a08541b82341be'
AND (
token = 'p8FaHJJAL0W6K2bmorhaBce9yfg8NsQPILZ9932UhEk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)