UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Vn6qDx7+a7kKLt96zQ8aX4NNGgPc8tU/tMO3zY4eQk4='
WHERE
key_id = '12aafac38358e07f12aa3fdff46ce2d161aa70f53ed154a87d04cef5f2c23292'
AND (
token = 'Vn6qDx7+a7kKLt96zQ8aX4NNGgPc8tU/tMO3zY4eQk4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)